package com.dao.purchase; 

import com.model.purchase.SupplyCompeteRecordMmModel; 
import java.sql.SQLException;
import java.util.List; 
import java.util.Map; 
import org.apache.ibatis.annotations.Param; 

public interface SupplyCompeteRecordMmDao  { 

	/**
	 * 新增
	 * 
	 * @author chenjun
	 * @date 2022/03/10
	 **/
	int insert(SupplyCompeteRecordMmModel supplyCompeteRecordMmModel);

	
	int deleteByInfId(String infId);
	
	List<SupplyCompeteRecordMmModel> selectByInfId(String infId);
	int deleteByInqId(String inqId);
	
	List<SupplyCompeteRecordMmModel> selectByInqId(String inqId);
	int deleteByComUuid(String comUuid);
	
	List<SupplyCompeteRecordMmModel> selectByComUuid(String comUuid);
	int deleteByPlanId(String planId);
	
	List<SupplyCompeteRecordMmModel> selectByPlanId(String planId);
	
	/**
	 * 刪除
	 * 
	 * @author chenjun
	 * @date 2022/03/10
	 **/
	int delete(@Param("infId")String infId,@Param("inqId")String inqId,@Param("comUuid")String comUuid,@Param("planId")String planId);

	/**
	 * 更新
	 * 
	 * @author chenjun
	 * @date 2022/03/10
	 **/
	int update(SupplyCompeteRecordMmModel supplyCompeteRecordMmModel);

	/**
	 * 查询 根据主键 id 查询
	 * 
	 * @author chenjun
	 * @date 2022/03/10
	 **/
	SupplyCompeteRecordMmModel load(@Param("infId")String infId,@Param("inqId")String inqId,@Param("comUuid")String comUuid,@Param("planId")String planId);


	// 列表
	List<SupplyCompeteRecordMmModel> selectList(Map<String, Object> map);

	// 列表总数
	int selectListCount(Map<String, Object> map);
 }